export const ProjectDeclareQueries = {
    GetProjectDeclares: `
    SELECT
     *
    FROM my_schema.project_declare
    `,
  
    GetProjectDeclareById: `
    SELECT
      id,
      projectDeclareName,
      projectDeclareDescription,
      projectDeclareStart,
      projectDeclareEnd,
      projectLevel,
      projectSource
    FROM my_schema.project_declare
    WHERE
      id = ?
    `,
  
    AddProjectDeclare: `
    INSERT INTO my_schema.project_declare (projectDeclareName, projectDeclareDescription, projectDeclareStart, projectDeclareEnd, projectSource,projectLevel, createdTime, updatedTime)
      VALUES ?
    `,

    UpdateProjectDeclareById: `
    UPDATE my_schema.project_declare
    SET ?
    WHERE
      id = ?
    `,
  
    DeleteProjectDeclareById: `
    DELETE FROM my_schema.project_declare
    WHERE
      id = ?
    `
  };